Job Description

Professional/Vendor Certification(s) in database administration that is required for the position to be filled. In addition, you must have one of the following:
1. A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management;
2. A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in \"1\" above; OR
3. A satisfactory equivalent of education and/or experience equivalent to “1” or “2” above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from
an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in \"1\" above.

• \t7 years’ experience in database administration of SQL Server database environments. \n-\tWorking knowledge of Microsoft SQL Server 2014/2016/2019 \n-\tThorough understanding of Relational Databases, T-SQL Scripting, Database Normalization best practices, database technologies, and concepts\n-\tProficient in Database Design with ability to perform logical to physical database transformation\n-\tProficient with SQL Development – ability to write and troubleshoot SQL Code as well as design and code stored procedures, functions, tables, views, triggers, indexes, constraints\n-\tExperience troubleshooting and resolving database integrity and performance issues\n-\tProficient with Performance Tuning and Query Optimization\n-\tExperience working with database automation tools to support CI/CD database activities\n-\tExperience working on small, medium and largescale projects\n-\tExperience with SSIS, SSRS and SSAS\n-\tExperience in support of ETL applications\n-\tExperience in data modeling principles/methods including conceptual, logical & physical data models.\n-\tExperience with Microsoft Azure SQL Database\n-\tDemonstrated ability to work collaboratively and effectively in a team environment as well as independently\n-\tAbility to work with minimum supervision where required as well as ability to effectively perform work under specific direction\n-\tPrior experience leading small teams\n-\tExcellent written and verbal communication skills

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.